You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
CONUS ARENATUS GRANULOSUS |
15.00 | |
PTEROPURPURA TRANSKEIANA |
20.00 | |
HARPA MAJOR |
12.00 | |
CERITHIUM LIFUENSE |
3.00 | |
TALPARIA TALPA |
8.00 | |
CONUS ARENATUS GRANULOSUS |
6.00 | |
CERITHIUM COLUMNA |
4.00 | |
PALMADUSTA ZICZAC |
6.00 | |
LUTRARIA PHILIPPINARUM |
8.00 | |
TURBO FORTISPIRALIS |
5.00 | |
CONUS LOROISII INSIGNIS |
20.00 | |
LAMBIS MILLEPEDA |
20.00 | |
EROSARIA GANGRANOSA |
12.00 | |
BISTOLIDA STOLIDA AURELIAE |
85.00 | |
RHINOCLAVIS FASCIATA |
4.00 | |
ISCHNOCHITON CONTRACTUS |
10.00 | |
EREMICONUS ALBELLUS |
40.00 | |
MONETARIA ANNULUS |
3.00 | |
EMPRESSOSTREA PHILIPPINARUM |
8.00 | |
BLASICRURA TERES TERES |
4.00 | |
CHELYCYPRAEA TESTUDINARIA |
12.00 | |
MORUM KURZI |
20.00 | |
Total: | 325.00 |